USE [texchange_db]
GO

/****** Object:  StoredProcedure [dbo].[SP_InsBanner]    Script Date: 05/29/2011 19:47:04 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE proc [dbo].[SP_InsBanner] 
  @link nvarchar(150),
  @position bit,
  @filename nvarchar(50),
  @isActive bit,
  @order int
as
	BEGIN
		SET NOCOUNT ON

		INSERT INTO Banners (link, position, [filename], isActive, _order) VALUES(@link, @position, @filename, @isActive, @order)

		SELECT NEWID = @@Identity
	END



GO


